翻訳と辞書 Words near each other ・ Review (TV series) ・ Review aggregator ・ Review and Herald ・ Review and Herald Publishing Association ・ Review and Preview ・ Review article ・ Review Board ・ Review Body ・ Review Body on Doctors' and Dentists' Remuneration ・ Review Centre ・ Review Conference of the Rome Statute of the International Criminal Court ・ Reverse SMS billing ・ Reverse sneezing ・ Reverse speech ・ Reverse Standards Conversion ・ Reverse star schema ・ Reverse stock split ・ Reverse stratigraphy ・ Reverse swing (disambiguation) ・ Reverse takeover ・ Reverse tape effects ・ Reverse telephone directory ・ Reverse Television ・ Reverse telnet ・ Reverse tolerance ・ Reverse transcriptase ・ Reverse Transcription Loop-mediated Isothermal Amplification ・ Reverse transcription polymerase chain reaction ・ Reverse transfection ・ Reverse triiodothyronine Dictionary Lists mini英和辞書 mini和英辞書 Webster 1913 Latin-English FOLDOC Wikipedia English ウィキペディア

翻訳と辞書　辞書検索 [ 開発暫定版 ] スポンサード リンク Reverse star schema ： ウィキペディア英語版 Reverse star schema This schema has been optimized for fast retrieval of large quantities of descriptive data. The design was derived from a warehouse star schema,〔(【引用サイトリンク】title= The Data Warehouse LifecycleToolkit )〕 and its adaptation for descriptive data required that certain key characteristics of the classic Star schema be ‘reversed’. == Model == The relation of the central table to those in the dimension tables is one-to-many or in some cases many-to-many rather than many-to-one; the primary keys of the central table are the foreign keys in dimension tables, and the main tables are in general, smaller than the dimension tables. Main table columns are typically the source of query constraints, as opposed to dimension tables in the classical star schema. By starting queries with the smaller table, many results are filtered out early in the querying process, thereby streamlining the entire search path. To add further flexibility, more than one main table is allowed, with main and submain tables having a one-to-many relation. Each main table can have its own dimension tables. To provide further query optimization, a data set can be partitioned into separate physical schemas on either the same database server or different database servers. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Reverse star schema」の詳細全文を読む スポンサード リンク 翻訳と辞書 : 翻訳のためのインターネットリソース Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.